Using Microsoft Excel For Everyday Problems (Practical Exercises Book 5) by Trygve Lerwick

Author:Trygve Lerwick [Lerwick, Trygve]
Language: eng
Format: azw3
Publisher: UNKNOWN
Published: 2017-03-13T04:00:00+00:00

Selecting a cell in column B causes the font color to be change from white to black, which makes the entry visible.

This is accomplished with two very simple VBA routines:

'Specify as a routine with name,

arguments and type

Sub Worksheet_SelectionChange

(ByVal Target As Excel.Range)

'Set the target range font color to black

Target.Font.Color = 1

'End the routine

End Sub

'Specify as a routine with name,

arguments and type

Sub EraseAnswers()

'Select column 2

Columns(2).Select

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.